﻿ALTER PROCEDURE [dbo].[usp_obraSocialXPlan_obtener] 
@ObraSocialXPlanId as int
AS

IF @ObraSocialXPlanId = 0 BEGIN
	SELECT * FROM ObraSocialXPlan
END
ELSE
	SELECT * FROM ObraSocialXPlan WHERE ObraSocialXPlanId = @ObraSocialXPlanId 